SAP Sybase ASE database target data types
The following table shows the SAP Sybase ASE database target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
SAP Sybase ASE does not support applying changes to binary data types in Batch optimized apply mode. For more information on Batch optimized apply mode, see Change Processing Tuning.
For information on how to view the data type that is mapped from the source, see the section for the source endpoint you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
| Qlik Replicate Data Types | SAP Sybase ASE Data Types |
|---|---|
|
BOOLEAN |
When the BIT is nullable, then: TINYINT When the BIT is not NULL, then: BIT |
|
BYTES |
VARBINARY (Length) |
|
DATE |
DATE |
|
TIME |
TIME |
|
DATETIME |
If scale is => 0 and =< 6, then: BIGDATETIME If scale is => 7 and =< 12, then: VARCHAR (37) |
|
INT1 |
TINYINT |
|
INT2 |
SMALLINT |
|
INT4 |
INTEGER |
|
INT8 |
BIGINT |
|
NUMERIC |
NUMERIC (p,s) |
|
REAL4 |
REAL |
|
REAL8 |
DOUBLE PRECISION |
|
STRING |
VARCHAR (Length) |
|
UINT1 |
TINYINT |
|
UINT2 |
UNSIGNED SMALLINT |
|
UINT4 |
UNSIGNED INTEGER |
|
UINT8 |
UNSIGNED BIGINT |
|
WSTRING |
VARCHAR (Length) |
|
BLOB |
IMAGE |
|
CLOB |
UNITEXT |
|
NCLOB |
TEXT |